USE [Biblioteca]
GO
/****** Object:  StoredProcedure [dbo].[sp_ActualizarPrestamo]    Script Date: 09/06/2012 22:26:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <02/09/2012>
-- Description:	<SP que permite actualizar un prestamo cuando un libro es devuelto>
-- =============================================
ALTER PROCEDURE [dbo].[sp_ActualizarPrestamo]
@idPrestamo int, 
@fechaRealDevolucion date

AS
UPDATE Prestamo
SET fechaRealDevolucion = @fechaRealDevolucion
WHERE idPrestamo = @idPrestamo
